Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 1 | init | Versioned | SQL | V1__init.sql | 00:00.234s |
| 2 | remove risk level table and create supply | Versioned | SQL | V2__remove_risk_level_table_and_create_supply.sql | 00:00.532s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
No migrations found
Flyway Exception: Migration V1__init.sql failed
-----------------------------
SQL State : 42S01
Error Code : 1050
Message : (conn=2199) Table 'flyway_schema_history' already exists
Location : src\main\resources\db\migration\V1__init.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V1__init.sql)
Line : 59
Statement : CREATE TABLE flyway_schema_history
(
installed_rank INT NOT NULL,
version VARCHAR(50) NULL,
`description` VARCHAR(200) NOT NULL,
type VARCHAR(20) NOT NULL,
script VARCHAR(1000) NOT NULL,
checksum INT DEFAULT NULL NULL,
installed_by VARCHAR(100) NOT NULL,
installed_on timestamp DEFAULT NOW() NOT NULL,
execution_time INT NOT NULL,
success BIT NOT NULL,
CONSTRAINT PK_FLYWAY_SCHEMA_HISTORY PRIMARY KEY (installed_rank)
)
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 1 | init | Versioned | SQL | V1__init.sql | 00:00.175s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 1 | init setup | Versioned | SQL | V1__init_setup.sql | 00:00.199s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 1 | init setup | Versioned | SQL | V1__init_setup.sql | 00:00.194s |
Flyway Exception: Migration V2__setup_v2.sql failed
---------------------------------
SQL State : HY000
Error Code : 1005
Message : (conn=268) Can't create table `mdm_equipment`.`supplies` (errno: 121 "Duplicate key on write or update")
Location : src\main\resources\db\migration\V2__setup_v2.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V2__setup_v2.sql)
Line : 160
Statement : ALTER TABLE supplies
ADD CONSTRAINT PROJECT FOREIGN KEY (project_id) REFERENCES projects (id) ON UPDATE RESTRICT ON DELETE SET NULL
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 1 | init setup | Versioned | SQL | V1__init_setup.sql | 00:00.192s |
Flyway Exception: Migration V2__setup_v2.sql failed
---------------------------------
SQL State : 42000
Error Code : 1091
Message : (conn=270) Can't DROP FOREIGN KEY `FK5sej5ndcwkmq5flmhwqksppkh`; check that it exists
Location : src\main\resources\db\migration\V2__setup_v2.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V2__setup_v2.sql)
Line : 160
Statement : ALTER TABLE equipment_supply
DROP FOREIGN KEY FK5sej5ndcwkmq5flmhwqksppkh
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 1 | Versioned | SQL | V1__.sql | 00:00.370s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 2 | create supplier table | Versioned | SQL | V2__create_supplier_table.sql | 00:00.079s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 1 | Versioned | SQL | V1__.sql | 00:00.395s | |
| 2 | create supplier table | Versioned | SQL | V2__create_supplier_table.sql | 00:00.059s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 1 | Versioned | SQL | V1__.sql | 00:00.463s | |
| 2 | create supplier table | Versioned | SQL | V2__create_supplier_table.sql | 00:00.069s |
| 3 | create repair table | Versioned | SQL | V3__create_repair_table.sql | 00:00.052s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 1 | Versioned | SQL | V1__.sql | 00:00.454s | |
| 2 | create supplier table | Versioned | SQL | V2__create_supplier_table.sql | 00:00.069s |
| 3 | create repair table | Versioned | SQL | V3__create_repair_table.sql | 00:00.098s |
| 4 | Versioned | SQL | V4__.sql | 00:00.210s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 1 | Versioned | SQL | V1__.sql | 00:00.377s | |
| 2 | create supplier table | Versioned | SQL | V2__create_supplier_table.sql | 00:00.061s |
Flyway Exception: Migration V3__create_repair_table.sql failed
--------------------------------------------
SQL State : HY000
Error Code : 1005
Message : (conn=459) Can't create table `mdm_equipment`.`repairs` (errno: 150 "Foreign key constraint is incorrectly formed")
Location : src\main\resources\db\migration\V3__create_repair_table.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V3__create_repair_table.sql)
Line : 28
Statement : ALTER TABLE repairs
ADD CONSTRAINT FK_REPAIRS_ON_REPAIR_COMPANY FOREIGN KEY (repair_company_id) REFERENCES suppliers (id) ON UPDATE RESTRICT ON DELETE SET NULL
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 1 | Versioned | SQL | V1__.sql | 00:00.643s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
No migrations found
Flyway Exception: Migration V1__.sql failed
-------------------------
SQL State : HY000
Error Code : 1005
Message : (conn=467) Can't create table `mdm_equipment`.`repairs` (errno: 150 "Foreign key constraint is incorrectly formed")
Location : src\main\resources\db\migration\V1__.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V1__.sql)
Line : 351
Statement : ALTER TABLE repairs
ADD CONSTRAINT FK_REPAIRS_ON_REPAIR_COMPANY FOREIGN KEY (repair_company_id) REFERENCES suppliers (id) ON UPDATE RESTRICT ON DELETE SET NULL
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 1 | Versioned | SQL | V1__.sql | 00:00.580s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 1 | Versioned | SQL | V1__.sql | 00:00.569s |
Flyway Exception: Migration V2__.sql failed
-------------------------
SQL State : HY000
Error Code : 1005
Message : (conn=12) Can't create table `mdm_equipment`.`users` (errno: 150 "Foreign key constraint is incorrectly formed")
Location : src\main\resources\db\migration\V2__.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V2__.sql)
Line : 65
Statement : ALTER TABLE users
ADD CONSTRAINT DEPARTMENT FOREIGN KEY (department_id) REFERENCES departments (id) ON UPDATE RESTRICT ON DELETE SET NULL
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 1 | Versioned | SQL | V1__.sql | 00:00.550s | |
| 2 | Versioned | SQL | V2__.sql | 00:00.239s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 1 | Versioned | SQL | V1__.sql | 00:00.609s | |
| 2 | Versioned | SQL | V2__.sql | 00:00.271s | |
| 3 | add service table and provider provides services table | Versioned | SQL | V3__add service table and provider_provides_services table.sql | 00:00.068s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 1 | Versioned | SQL | V1__.sql | 00:00.563s | |
| 2 | Versioned | SQL | V2__.sql | 00:00.247s | |
| 3 | add service table and provider provides services table | Versioned | SQL | V3__add service table and provider_provides_services table.sql | 00:00.071s |
Flyway Exception: Migration V3_1__.sql failed
---------------------------
SQL State : HY000
Error Code : 1553
Message : (conn=200) Cannot drop index 'FK_HANDOVERS_ON_DEPARTMENT': needed in a foreign key constraint
Location : src\main\resources\db\migration\V3_1__.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V3_1__.sql)
Line : 4
Statement : ALTER TABLE handovers
DROP COLUMN department_id
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 1 | Versioned | SQL | V1__.sql | 00:00.562s | |
| 2 | Versioned | SQL | V2__.sql | 00:00.265s | |
| 3 | add service table and provider provides services table | Versioned | SQL | V3__add service table and provider_provides_services table.sql | 00:00.071s |
Flyway Exception: Migration V3_1__.sql failed
---------------------------
SQL State : HY000
Error Code : 1828
Message : (conn=204) Cannot drop column 'department_id': needed in a foreign key constraint 'mdm_equipment/FK_HANDOVERS_ON_DEPARTMENT'
Location : src\main\resources\db\migration\V3_1__.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V3_1__.sql)
Line : 5
Statement : ALTER TABLE handovers
DROP COLUMN department_id
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 1 | Versioned | SQL | V1__.sql | 00:00.566s | |
| 2 | Versioned | SQL | V2__.sql | 00:00.288s | |
| 3 | add service table and provider provides services table | Versioned | SQL | V3__add service table and provider_provides_services table.sql | 00:00.069s |
Flyway Exception: Migration V3_1__.sql failed
---------------------------
SQL State : HY000
Error Code : 1828
Message : (conn=208) Cannot drop column 'department_id': needed in a foreign key constraint 'mdm_equipment/FK_HANDOVERS_ON_DEPARTMENT'
Location : src\main\resources\db\migration\V3_1__.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V3_1__.sql)
Line : 5
Statement : ALTER TABLE handovers
DROP COLUMN department_id
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
No migrations found
Flyway Exception: Migration V1__.sql failed
-------------------------
SQL State : HY000
Error Code : 1005
Message : (conn=212) Can't create table `mdm_equipment`.`users` (errno: 150 "Foreign key constraint is incorrectly formed")
Location : src\main\resources\db\migration\V1__.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V1__.sql)
Line : 387
Statement : ALTER TABLE users
ADD CONSTRAINT DEPARTMENT FOREIGN KEY (department_id) REFERENCES departments (id) ON UPDATE CASCADE ON DELETE SET NULL
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
No migrations found
Flyway Exception: Migration V1__.sql failed
-------------------------
SQL State : HY000
Error Code : 1005
Message : (conn=217) Can't create table `mdm_equipment`.`handovers` (errno: 150 "Foreign key constraint is incorrectly formed")
Location : src\main\resources\db\migration\V1__.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V1__.sql)
Line : 411
Statement : ALTER TABLE handovers
ADD CONSTRAINT FK_HANDOVERS_ON_DEPARTMENT FOREIGN KEY (department_id) REFERENCES departments (id) ON UPDATE CASCADE ON DELETE SET NULL
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
No migrations found
Flyway Exception: Migration V1__.sql failed
-------------------------
SQL State : HY000
Error Code : 1005
Message : (conn=220) Can't create table `mdm_equipment`.`handovers` (errno: 150 "Foreign key constraint is incorrectly formed")
Location : src\main\resources\db\migration\V1__.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V1__.sql)
Line : 411
Statement : ALTER TABLE handovers
ADD CONSTRAINT FK_HANDOVERS_ON_DEPARTMENT FOREIGN KEY (department_id) REFERENCES departments (id) ON UPDATE CASCADE ON DELETE SET NULL
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
No migrations found
Flyway Exception: Migration V1__.sql failed
-------------------------
SQL State : HY000
Error Code : 1005
Message : (conn=223) Can't create table `mdm_equipment`.`handovers` (errno: 150 "Foreign key constraint is incorrectly formed")
Location : src\main\resources\db\migration\V1__.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V1__.sql)
Line : 417
Statement : ALTER TABLE handovers
ADD CONSTRAINT FK_HANDOVERS_ON_RESPONSIBLE_PERSON FOREIGN KEY (responsible_person_id) REFERENCES users (id) ON UPDATE CASCADE ON DELETE SET NULL
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
No migrations found
Flyway Exception: Migration V1__.sql failed
-------------------------
SQL State : HY000
Error Code : 1005
Message : (conn=226) Can't create table `mdm_equipment`.`inventories` (errno: 150 "Foreign key constraint is incorrectly formed")
Location : src\main\resources\db\migration\V1__.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V1__.sql)
Line : 426
Statement : ALTER TABLE inventories
ADD CONSTRAINT FK_INVENTORIES_ON_INVENTORY_PERSON FOREIGN KEY (inventory_person_id) REFERENCES users (id) ON UPDATE CASCADE ON DELETE SET NULL
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
No migrations found
Flyway Exception: Migration V1__.sql failed
-------------------------
SQL State : HY000
Error Code : 1005
Message : (conn=229) Can't create table `mdm_equipment`.`repairs` (errno: 150 "Foreign key constraint is incorrectly formed")
Location : src\main\resources\db\migration\V1__.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V1__.sql)
Line : 450
Statement : ALTER TABLE repairs
ADD CONSTRAINT FK_REPAIRS_ON_REPORTING_PERSON FOREIGN KEY (reporting_person_id) REFERENCES users (id) ON UPDATE CASCADE ON DELETE SET NULL
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
No migrations found
Flyway Exception: Migration V1__.sql failed
-------------------------
SQL State : HY000
Error Code : 1005
Message : (conn=232) Can't create table `mdm_equipment`.`suppliers` (errno: 150 "Foreign key constraint is incorrectly formed")
Location : src\main\resources\db\migration\V1__.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V1__.sql)
Line : 453
Statement : ALTER TABLE suppliers
ADD CONSTRAINT FK_SUPPLIERS_ON_CONTACT_PERSON FOREIGN KEY (contact_person_id) REFERENCES users (id) ON UPDATE CASCADE ON DELETE SET NULL
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
No migrations found
Flyway Exception: Migration V1__.sql failed
-------------------------
SQL State : HY000
Error Code : 1005
Message : (conn=235) Can't create table `mdm_equipment`.`transfers` (errno: 150 "Foreign key constraint is incorrectly formed")
Location : src\main\resources\db\migration\V1__.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V1__.sql)
Line : 477
Statement : ALTER TABLE transfers
ADD CONSTRAINT FK_TRANSFERS_ON_FROM_DEPARTMENT FOREIGN KEY (from_department_id) REFERENCES departments (id) ON UPDATE CASCADE ON DELETE SET NULL
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
No migrations found
Flyway Exception: Migration V1__.sql failed
-------------------------
SQL State : HY000
Error Code : 1005
Message : (conn=238) Can't create table `mdm_equipment`.`provider_provides_services` (errno: 150 "Foreign key constraint is incorrectly formed")
Location : src\main\resources\db\migration\V1__.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V1__.sql)
Line : 498
Statement : ALTER TABLE provider_provides_services
ADD CONSTRAINT fk_proproser_on_service FOREIGN KEY (service_id) REFERENCES services (id) ON UPDATE CASCADE ON DELETE SET NULL
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 1 | Versioned | SQL | V1__.sql | 00:00.964s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 1 | Versioned | SQL | V1__.sql | 00:00.993s | |
| 1.1 | Versioned | SQL | V1_1__.sql | 00:00.011s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 1 | Versioned | SQL | V1__.sql | 00:00.931s | |
| 1.1 | Versioned | SQL | V1_1__.sql | 00:00.011s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 2 | add file storage table | Versioned | SQL | V2__add file storage table.sql | 00:00.027s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 2.1 | remove created at and updated at | Versioned | SQL | V2_1__ remove created at and updated at.sql | 00:00.129s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 2.2 | rename acceptance date to approval date | Versioned | SQL | V2_2__ rename acceptance_date to approval_date.sql | 00:00.031s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
No migrations found
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 2.4 | create equipment user table | Versioned | SQL | V2_4__ create equipment_user table.sql | 00:00.045s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 2.5 | Versioned | SQL | V2_5__.sql | 00:00.026s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 2.6 | remove image field in repair table | Versioned | SQL | V2.6__remove image field in repair table.sql | 00:00.012s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 2.7 | change associated entity id type from string to long | Versioned | SQL | V2_7__ change associated entity id type from string to long.sql | 00:00.028s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 2.8 | add content type in file storage table | Versioned | SQL | V2_8__ add content type in file storage table.sql | 00:00.023s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 1 | Versioned | SQL | V1__.sql | 00:01.085s | |
| 1.1 | Versioned | SQL | V1_1__.sql | 00:00.014s | |
| 2 | add file storage table | Versioned | SQL | V2__add file storage table.sql | 00:00.010s |
| 2.1 | remove created at and updated at | Versioned | SQL | V2_1__ remove created at and updated at.sql | 00:00.122s |
| 2.2 | rename acceptance date to approval date | Versioned | SQL | V2_2__ rename acceptance_date to approval_date.sql | 00:00.019s |
| 2.3 | remove equipment status and handover status from handovers table | Versioned | SQL | V2_3__ remove equipment_status and handover_status from handovers table.sql | 00:00.021s |
| 2.4 | create equipment user table | Versioned | SQL | V2_4__ create equipment_user table.sql | 00:00.034s |
| 2.5 | Versioned | SQL | V2_5__.sql | 00:00.025s | |
| 2.6 | remove image field in repair table | Versioned | SQL | V2.6__remove image field in repair table.sql | 00:00.011s |
| 2.7 | change associated entity id type from string to long | Versioned | SQL | V2_7__ change associated entity id type from string to long.sql | 00:00.019s |
| 2.8 | add content type in file storage table | Versioned | SQL | V2_8__ add content type in file storage table.sql | 00:00.051s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
No migrations found
Flyway Exception: Migration V2_9__add password filed in users table.sql failed
------------------------------------------------------------
SQL State : 01000
Error Code : 1265
Message : (conn=1604) Data truncated for column 'password' at row 1
Location : src\main\resources\db\migration\V2_9__add password filed in users table.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V2_9__add password filed in users table.sql)
Line : 4
Statement : ALTER TABLE users
MODIFY password VARCHAR(255) NOT NULL
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
No migrations found
Flyway Exception: Migration V2_9__ add password field to user table.sql failed
------------------------------------------------------------
SQL State : 42S21
Error Code : 1060
Message : (conn=1610) Duplicate column name 'password'
Location : src\main\resources\db\migration\V2_9__ add password field to user table.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V2_9__ add password field to user table.sql)
Line : 1
Statement : ALTER TABLE users
ADD password VARCHAR(255) NULL
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 2.9 | add password field to user table | Versioned | SQL | V2_9__ add password field to user table.sql | 00:00.029s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 3 | add forgot password table | Versioned | SQL | V3__ add forgot password table.sql | 00:00.061s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 3.1 | Versioned | SQL | V3_1__.sql | 00:00.031s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 3.3 | remove inventory status | Versioned | SQL | V3_3__ remove inventory status.sql | 00:00.035s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 4 | add equipment group table | Versioned | SQL | V4__add equipment group table.sql | 00:00.040s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 4.1 | update not null constraint on equipment categories table and equipment groups table | Versioned | SQL | V4_1__update not null constraint on equipment categories table and equipment groups table.sql | 00:00.082s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 4.2 | Versioned | SQL | V4_2__.sql | 00:00.035s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 4.3 | drop unique on alias in equipment categories table | Versioned | SQL | V4_3__drop unique on alias in equipment categories table.sql | 00:00.011s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 5 | create equipment unit table | Versioned | SQL | V5__create equipment unit table.sql | 00:00.061s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
No migrations found
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 5.1 | drop unique constraint on hash code | Versioned | SQL | V5_1__drop unique constraint on hash_code.sql | 00:00.011s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 5.2 | add created by in handovers table | Versioned | SQL | V5_2__ add created by in handovers table.sql | 00:00.058s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 5.4 | add approval on handover table | Versioned | SQL | V5_4__add approval on handover table.sql | 00:00.038s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
No migrations found
Flyway Exception: Migration V5_5__add approval on handover table.sql failed
---------------------------------------------------------
SQL State : 42S21
Error Code : 1060
Message : (conn=246) Duplicate column name 'approval_date'
Location : src\main\resources\db\migration\V5_5__add approval on handover table.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V5_5__add approval on handover table.sql)
Line : 1
Statement : ALTER TABLE handovers
ADD approval_date date NULL
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
No migrations found
Flyway Exception: Migration V5_5__add approval on handover table.sql failed
---------------------------------------------------------
SQL State : 42S21
Error Code : 1060
Message : (conn=249) Duplicate column name 'approval_date'
Location : src\main\resources\db\migration\V5_5__add approval on handover table.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V5_5__add approval on handover table.sql)
Line : 1
Statement : ALTER TABLE handovers
ADD approval_date date NULL
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 5.5 | add approval on handover table | Versioned | SQL | V5_5__add approval on handover table.sql | 00:00.035s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 6 | remove equipment user many to many relationship | Versioned | SQL | V6__remove equipment user many to many relationship.sql | 00:00.042s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 7 | add notification, notification config and user read notification table | Versioned | SQL | V7__add notification, notification config and user read notification table.sql | 00:00.087s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 7.1 | modify notifications content from text to json | Versioned | SQL | V7_1__modify notifications content from text to json.sql | 00:00.013s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 7.2 | add note filed to handovers table | Versioned | SQL | V7_2__ add note filed to handovers table.sql | 00:00.018s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 7.3 | alter notification and notification config table | Versioned | SQL | V7_3__ alter notification and notification config table.sql | 00:00.113s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 7.4 | add note and status on handovers table | Versioned | SQL | V7_4__ add note and status on handovers table.sql | 00:00.074s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 8 | modify all data type from date to datetime | Versioned | SQL | V8__ modify all data type from date to datetime.sql | 00:00.319s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
No migrations found
Flyway Exception: Migration V9__add repair ticket, broken report ticket, ticket processes, add not null constraint on some local date time data type.sql failed
----------------------------------------------------------------------------------------------------------------------------------------------
SQL State : 42000
Error Code : 1072
Message : (conn=79) Key column '' doesn't exist in table
Location : src\main\resources\db\migration\V9__add repair ticket, broken report ticket, ticket processes, add not null constraint on some local date time data type.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V9__add repair ticket, broken report ticket, ticket processes, add not null constraint on some local date time data type.sql)
Line : 54
Statement : ALTER TABLE broken_report_tickets
ADD CONSTRAINT code UNIQUE (``)
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
No migrations found
Flyway Exception: Migration V9__add repair ticket, broken report ticket, ticket processes, add not null constraint on some local date time data type.sql failed
----------------------------------------------------------------------------------------------------------------------------------------------
SQL State : 42S01
Error Code : 1050
Message : (conn=87) Table 'broken_report_ticket_processes' already exists
Location : src\main\resources\db\migration\V9__add repair ticket, broken report ticket, ticket processes, add not null constraint on some local date time data type.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V9__add repair ticket, broken report ticket, ticket processes, add not null constraint on some local date time data type.sql)
Line : 1
Statement : CREATE TABLE broken_report_ticket_processes
(
id BIGINT AUTO_INCREMENT NOT NULL,
creator_id BIGINT NULL,
created_date datetime NOT NULL,
creator_note TEXT NULL,
approval_date datetime NULL,
approver_note TEXT NULL,
approver_id BIGINT NULL,
is_accepted BIT(1) NULL,
broken_report_ticket_id BIGINT NOT NULL,
CONSTRAINT pk_broken_report_ticket_processes PRIMARY KEY (id)
)
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 9 | add repair ticket, broken report ticket, ticket processes, add not null constraint on some local date time data type | Versioned | SQL | V9__add repair ticket, broken report ticket, ticket processes, add not null constraint on some local date time data type.sql | 00:00.363s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 10 | drop all ticket processes table | Versioned | SQL | V10__ drop all ticket processes table.sql | 00:00.261s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 1 | Versioned | SQL | V1__.sql | 00:00.900s | |
| 1.1 | Versioned | SQL | V1_1__.sql | 00:00.011s | |
| 2 | add file storage table | Versioned | SQL | V2__add file storage table.sql | 00:00.017s |
| 2.1 | remove created at and updated at | Versioned | SQL | V2_1__ remove created at and updated at.sql | 00:00.163s |
| 2.2 | rename acceptance date to approval date | Versioned | SQL | V2_2__ rename acceptance_date to approval_date.sql | 00:00.020s |
| 2.3 | remove equipment status and handover status from handovers table | Versioned | SQL | V2_3__ remove equipment_status and handover_status from handovers table.sql | 00:00.022s |
| 2.4 | create equipment user table | Versioned | SQL | V2_4__ create equipment_user table.sql | 00:00.046s |
| 2.5 | Versioned | SQL | V2_5__.sql | 00:00.027s | |
| 2.6 | remove image field in repair table | Versioned | SQL | V2.6__remove image field in repair table.sql | 00:00.012s |
| 2.7 | change associated entity id type from string to long | Versioned | SQL | V2_7__ change associated entity id type from string to long.sql | 00:00.020s |
| 2.8 | add content type in file storage table | Versioned | SQL | V2_8__ add content type in file storage table.sql | 00:00.034s |
| 2.9 | add password field to user table | Versioned | SQL | V2_9__ add password field to user table.sql | 00:00.083s |
| 3 | add forgot password table | Versioned | SQL | V3__ add forgot password table.sql | 00:00.027s |
Flyway Exception: Migration V3_1__.sql failed
---------------------------
SQL State : 42S22
Error Code : 1054
Message : (conn=216) Unknown column 'otp' in 'forgot_password'
Location : src\main\resources\db\migration\V3_1__.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V3_1__.sql)
Line : 1
Statement : ALTER TABLE forgot_password
CHANGE otp uuid VARCHAR(255)
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 1 | Versioned | SQL | V1__.sql | 00:00.987s | |
| 1.1 | Versioned | SQL | V1_1__.sql | 00:00.011s | |
| 2 | add file storage table | Versioned | SQL | V2__add file storage table.sql | 00:00.007s |
| 2.1 | remove created at and updated at | Versioned | SQL | V2_1__ remove created at and updated at.sql | 00:00.124s |
| 2.2 | rename acceptance date to approval date | Versioned | SQL | V2_2__ rename acceptance_date to approval_date.sql | 00:00.019s |
| 2.3 | remove equipment status and handover status from handovers table | Versioned | SQL | V2_3__ remove equipment_status and handover_status from handovers table.sql | 00:00.020s |
| 2.4 | create equipment user table | Versioned | SQL | V2_4__ create equipment_user table.sql | 00:00.036s |
| 2.5 | Versioned | SQL | V2_5__.sql | 00:00.033s | |
| 2.6 | remove image field in repair table | Versioned | SQL | V2.6__remove image field in repair table.sql | 00:00.012s |
| 2.7 | change associated entity id type from string to long | Versioned | SQL | V2_7__ change associated entity id type from string to long.sql | 00:00.037s |
| 2.8 | add content type in file storage table | Versioned | SQL | V2_8__ add content type in file storage table.sql | 00:00.035s |
| 2.9 | add password field to user table | Versioned | SQL | V2_9__ add password field to user table.sql | 00:00.085s |
| 3 | add forgot password table | Versioned | SQL | V3__ add forgot password table.sql | 00:00.055s |
| 3.3 | remove inventory status | Versioned | SQL | V3_3__ remove inventory status.sql | 00:00.017s |
| 4 | add equipment group table | Versioned | SQL | V4__add equipment group table.sql | 00:00.028s |
| 4.1 | update not null constraint on equipment categories table and equipment groups table | Versioned | SQL | V4_1__update not null constraint on equipment categories table and equipment groups table.sql | 00:00.078s |
| 4.2 | Versioned | SQL | V4_2__.sql | 00:00.025s | |
| 4.3 | drop unique on alias in equipment categories table | Versioned | SQL | V4_3__drop unique on alias in equipment categories table.sql | 00:00.009s |
| 5 | create equipment unit table | Versioned | SQL | V5__create equipment unit table.sql | 00:00.030s |
| 5.1 | drop unique constraint on hash code | Versioned | SQL | V5_1__drop unique constraint on hash_code.sql | 00:00.011s |
| 5.2 | add created by in handovers table | Versioned | SQL | V5_2__ add created by in handovers table.sql | 00:00.040s |
| 5.4 | remove document column on handovers and transfers table | Versioned | SQL | V5_4__ remove document column on handovers and transfers table.sql | 00:00.017s |
| 5.5 | add approval on handover table | Versioned | SQL | V5_5__add approval on handover table.sql | 00:00.039s |
Flyway Exception: Migration V6__remove equipment user many to many relationship.sql failed
------------------------------------------------------------------------
SQL State : 42000
Error Code : 1091
Message : (conn=220) Can't DROP COLUMN `document`; check that it exists
Location : src\main\resources\db\migration\V6__remove equipment user many to many relationship.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V6__remove equipment user many to many relationship.sql)
Line : 9
Statement : ALTER TABLE handovers
DROP COLUMN document
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 1 | Versioned | SQL | V1__.sql | 00:00.904s | |
| 1.1 | Versioned | SQL | V1_1__.sql | 00:00.011s | |
| 2 | add file storage table | Versioned | SQL | V2__add file storage table.sql | 00:00.009s |
| 2.1 | remove created at and updated at | Versioned | SQL | V2_1__ remove created at and updated at.sql | 00:00.125s |
| 2.2 | rename acceptance date to approval date | Versioned | SQL | V2_2__ rename acceptance_date to approval_date.sql | 00:00.019s |
| 2.3 | remove equipment status and handover status from handovers table | Versioned | SQL | V2_3__ remove equipment_status and handover_status from handovers table.sql | 00:00.020s |
| 2.4 | create equipment user table | Versioned | SQL | V2_4__ create equipment_user table.sql | 00:00.039s |
| 2.5 | Versioned | SQL | V2_5__.sql | 00:00.028s | |
| 2.6 | remove image field in repair table | Versioned | SQL | V2.6__remove image field in repair table.sql | 00:00.011s |
| 2.7 | change associated entity id type from string to long | Versioned | SQL | V2_7__ change associated entity id type from string to long.sql | 00:00.018s |
| 2.8 | add content type in file storage table | Versioned | SQL | V2_8__ add content type in file storage table.sql | 00:00.023s |
| 2.9 | add password field to user table | Versioned | SQL | V2_9__ add password field to user table.sql | 00:00.080s |
| 3 | add forgot password table | Versioned | SQL | V3__ add forgot password table.sql | 00:00.021s |
| 3.3 | remove inventory status | Versioned | SQL | V3_3__ remove inventory status.sql | 00:00.016s |
| 4 | add equipment group table | Versioned | SQL | V4__add equipment group table.sql | 00:00.026s |
| 4.1 | update not null constraint on equipment categories table and equipment groups table | Versioned | SQL | V4_1__update not null constraint on equipment categories table and equipment groups table.sql | 00:00.080s |
| 4.2 | Versioned | SQL | V4_2__.sql | 00:00.029s | |
| 4.3 | drop unique on alias in equipment categories table | Versioned | SQL | V4_3__drop unique on alias in equipment categories table.sql | 00:00.020s |
| 5 | create equipment unit table | Versioned | SQL | V5__create equipment unit table.sql | 00:00.038s |
| 5.1 | drop unique constraint on hash code | Versioned | SQL | V5_1__drop unique constraint on hash_code.sql | 00:00.012s |
| 5.2 | add created by in handovers table | Versioned | SQL | V5_2__ add created by in handovers table.sql | 00:00.034s |
| 5.4 | remove document column on handovers and transfers table | Versioned | SQL | V5_4__ remove document column on handovers and transfers table.sql | 00:00.017s |
| 5.5 | add approval on handover table | Versioned | SQL | V5_5__add approval on handover table.sql | 00:00.033s |
| 6 | remove equipment user many to many relationship | Versioned | SQL | V6__remove equipment user many to many relationship.sql | 00:00.030s |
| 7 | add notification, notification config and user read notification table | Versioned | SQL | V7__add notification, notification config and user read notification table.sql | 00:00.048s |
| 7.1 | modify notifications content from text to json | Versioned | SQL | V7_1__modify notifications content from text to json.sql | 00:00.009s |
| 7.2 | add note filed to handovers table | Versioned | SQL | V7_2__ add note filed to handovers table.sql | 00:00.018s |
| 7.3 | alter notification and notification config table | Versioned | SQL | V7_3__ alter notification and notification config table.sql | 00:00.055s |
| 7.4 | add note and status on handovers table | Versioned | SQL | V7_4__ add note and status on handovers table.sql | 00:00.038s |
| 8 | modify all data type from date to datetime | Versioned | SQL | V8__ modify all data type from date to datetime.sql | 00:00.293s |
| 9 | add repair ticket, broken report ticket, ticket processes, add not null constraint on some local date time data type | Versioned | SQL | V9__add repair ticket, broken report ticket, ticket processes, add not null constraint on some local date time data type.sql | 00:00.384s |
| 10 | drop all ticket processes table | Versioned | SQL | V10__ drop all ticket processes table.sql | 00:00.291s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 10.1 | add priority to broken report ticket table | Versioned | SQL | V10_1__ add priority to broken report ticket table.sql | 00:00.101s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 10.2 | rename broken report ticket to report broken tickets | Versioned | SQL | V10_2__rename broken_report_ticket to report_broken_tickets.sql | 00:00.044s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 10.4 | add repair note | Versioned | SQL | V10_4__add repair note.sql | 00:00.023s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 10.5 | add acceptance tester id on repair ticket table | Versioned | SQL | V10_5__ add acceptance tester id on repair ticket table.sql | 00:00.060s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 10.6 | add acceptance test date | Versioned | SQL | V10_6__ add acceptance test date .sql | 00:00.032s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 11 | alter transfer class to extend ticket class | Versioned | SQL | V11__ alter transfer class to extend ticket class.sql | 00:00.186s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 12 | alter liquidations table | Versioned | SQL | V12__alter liquidations table.sql | 00:00.220s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 13 | rename to maintenance tickets and transfer tickets | Versioned | SQL | V13__ rename to maintenance_tickets and transfer_tickets.sql | 00:00.049s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 14 | add some fields to maintenance table | Versioned | SQL | V14__add some fields to maintenance table.sql | 00:00.193s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 14.1 | drop maintenance status | Versioned | SQL | V14_1__ drop maintenance status.sql | 00:00.023s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 14.2 | add next time maintenances | Versioned | SQL | V14_2__add next time maintenances.sql | 00:00.032s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 14.3 | remove next time in maintenance tickets taable | Versioned | SQL | V14_3__ remove next time in maintenance tickets taable.sql | 00:00.030s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 14.4 | add not null constraint on some field in equipments table | Versioned | SQL | V14_4__ add not null constraint on some field in equipments table.sql | 00:00.196s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 14.5 | add coloumn maintenance company id on maintenance table | Versioned | SQL | V14_5__ add coloumn maintenance company id on maintenance table.sql | 00:00.046s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 15 | alter inspection class to extend ticket class | Versioned | SQL | V15__ alter inspection class to extend ticket class.sql | 00:00.180s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 15.1 | rename inspections table to inspection tickets | Versioned | SQL | V15_1__ rename inspections table to inspection_tickets.sql | 00:00.011s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 15.2 | rename maintenance company id to inspection company id | Versioned | SQL | V15_2__rename maintenance company id to inspection company id.sql | 00:00.022s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 15.3 | add inspection evaluation status | Versioned | SQL | V15_3__add inspection evaluation status.sql | 00:00.015s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 15.4 | drop not null constraint on last time in inspection tickets table | Versioned | SQL | V15_4__drop not null constraint on last_time in inspection_tickets table.sql | 00:00.014s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 15.5 | rename table liquidations to liquidation tickets | Versioned | SQL | V15_5__rename table liquidations to liquidation_tickets.sql | 00:00.018s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 15.6 | rename handovers to handover tickets | Versioned | SQL | V15_6__rename handovers to handover_tickets.sql | 00:00.035s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
No migrations found
Flyway Exception: Migration V16__ handover ticket entity now extend ticket class.sql failed ------------------------------------------------------------------------- SQL State : 22007 Error Code : 1292 Message : (conn=589) Incorrect datetime value: '' for column `mdm_equipment`.`handover_tickets`.`created_date` at row 1 Location : src\main\resources\db\migration\V16__ handover ticket entity now extend ticket class.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V16__ handover ticket entity now extend ticket class.sql) Line : 22 Statement : UPDATE handover_tickets SET created_date = '' WHERE created_date IS NULL
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
No migrations found
Flyway Exception: Migration V16__ handover ticket entity now extend ticket class.sql failed
-------------------------------------------------------------------------
SQL State : 42S21
Error Code : 1060
Message : (conn=592) Duplicate column name 'code'
Location : src\main\resources\db\migration\V16__ handover ticket entity now extend ticket class.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V16__ handover ticket entity now extend ticket class.sql)
Line : 1
Statement : ALTER TABLE handover_tickets
ADD code VARCHAR(255) NULL
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 16 | handover ticket entity now extend ticket class | Versioned | SQL | V16__ handover ticket entity now extend ticket class.sql | 00:00.099s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 16.1 | drop department on handover ticket table | Versioned | SQL | V16_1__drop department on handover ticket table.sql | 00:00.037s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 17 | remove clinic inspection, cv radiation, external assessment, radiation inspection | Versioned | SQL | V17__remove clinic inspection, cv radiation, external assessment, radiation inspection.sql | 00:00.109s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 18 | add department id to handover table | Versioned | SQL | V18__add department id to handover table.sql | 00:00.062s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 18.1 | add report broken ticket id field to repair table | Versioned | SQL | V18_1__add report broken ticket id field to repair table.sql | 00:00.056s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 18.2 | remove report broken ticket id and add not null on equipment unit name field | Versioned | SQL | V18_2__remove report broken ticket id and add not null on equipment unit name field.sql | 00:00.077s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 19 | Versioned | SQL | V19__.sql | 00:00.275s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
No migrations found
Flyway Exception: Migration V20__.sql failed
--------------------------
SQL State : 22007
Error Code : 1292
Message : (conn=180) Truncated incorrect INTEGER value: 'DDT'
Location : src\main\resources\db\migration\V20__.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V20__.sql)
Line : 1
Statement : ALTER TABLE notification_configs
CHANGE role_can_receive_notification role_id BIGINT
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
No migrations found
Flyway Exception: Migration V20__.sql failed
--------------------------
SQL State : HY000
Error Code : 1830
Message : (conn=183) Column 'department_id' cannot be NOT NULL: needed in a foreign key constraint 'mdm_equipment/FK_HANDOVER_TICKETS_ON_DEPARTMENT' SET NULL
Location : src\main\resources\db\migration\V20__.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V20__.sql)
Line : 10
Statement : ALTER TABLE handover_tickets
MODIFY department_id BIGINT NOT NULL
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
No migrations found
Flyway Exception: Migration V20__update notification configs table, rename role_can_receive notification to role id.sql failed
------------------------------------------------------------------------------------------------------------
SQL State : 42S22
Error Code : 1054
Message : (conn=186) Unknown column 'role_can_receive_notification' in 'notification_configs'
Location : src\main\resources\db\migration\V20__update notification configs table, rename role_can_receive notification to role id.sql (C:\Intellij\mdm\equipment-service\src\main\resources\db\migration\V20__update notification configs table, rename role_can_receive notification to role id.sql)
Line : 1
Statement : ALTER TABLE notification_configs
CHANGE role_can_receive_notification role_id BIGINT
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 20 | update notification configs table, rename role can receive notification to role id | Versioned | SQL | V20__update notification configs table, rename role_can_receive notification to role id.sql | 00:00.016s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 20.1 | add foreign key constraint on role table | Versioned | SQL | V20_1__add foreign key constraint on role table.sql | 00:00.023s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 21 | add supply group table | Versioned | SQL | V21__add supply group table.sql | 00:00.036s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 22 | drop supply groups | Versioned | SQL | V22__drop supply groups.sql | 00:00.124s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 22.1 | remove audit on supplies table | Versioned | SQL | V22_1__remove audit on supplies table.sql | 00:00.030s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 22.3 | drop unique indexes | Versioned | SQL | V22_3__drop unique indexes.sql | 00:00.073s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 22.4 | drop column code on supplies table | Versioned | SQL | V22_4__drop column code on supplies table.sql | 00:00.029s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 22.5 | drop column status on supply | Versioned | SQL | V22_5__drop column status on supply.sql | 00:00.013s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 23 | add last maintenance date and last inspection date | Versioned | SQL | V23__add last maintenance date and last inspection date.sql | 00:00.052s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet
Migration report
| Version | Description | Category | Type | Filepath | ExecutionTime |
|---|---|---|---|---|---|
| 23.1 | rename last time inspection to inspection date, and same with maintenance | Versioned | SQL | V23_1__rename last time inspection to inspection date, and same with maintenance.sql | 00:00.020s |
Change reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Drift reporting is not included in your current Flyway license. Upgrade to Flyway Enterprise to gain access.
Dry Run is not included in your current Flyway license. Upgrade to Flyway Teams or Enterprise to gain access.
No code analysis report available yet